﻿/****** Object:  Default [DF__Benutzer__OrgKey__68487DD7]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Benutzer] ADD  DEFAULT ((0)) FOR [OrgKey]
GO
/****** Object:  Default [DF__Klassifik__OrgKe__693CA210]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Klassifikation] ADD  DEFAULT ((0)) FOR [OrgKey]
GO
/****** Object:  Default [DF__Klassifik__Klass__6A30C649]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Klassifikation] ADD  DEFAULT ((0)) FOR [KlassKey]
GO
/****** Object:  Default [DF__Klassifikat__Key__6B24EA82]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Klassifikation] ADD  DEFAULT ((0)) FOR [Key]
GO
/****** Object:  Default [DF__Kontakt__Status__6C190EBB]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Kontakt] ADD  DEFAULT ((0)) FOR [Status]
GO
/****** Object:  Default [DF__KontaktEr__Inhal__6D0D32F4]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[KontaktErgebnis] ADD  DEFAULT ((0)) FOR [InhaltKey]
GO
/****** Object:  Default [DF__KontaktOr__Konta__6E01572D]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[KontaktOrganisation] ADD  DEFAULT ((0)) FOR [KontaktKey]
GO
/****** Object:  Default [DF__KontaktOr__OrgKe__6EF57B66]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[KontaktOrganisation] ADD  DEFAULT ((0)) FOR [OrgKey]
GO
/****** Object:  Default [DF__KontaktPe__Konta__6FE99F9F]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[KontaktPerson] ADD  DEFAULT ((0)) FOR [KontaktKey]
GO
/****** Object:  Default [DF__KontaktPe__PersK__70DDC3D8]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[KontaktPerson] ADD  DEFAULT ((0)) FOR [PersKey]
GO
/****** Object:  Default [DF__KontaktPe__Aufwa__71D1E811]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[KontaktPerson] ADD  DEFAULT ((0)) FOR [Aufwand_Soll]
GO
/****** Object:  Default [DF__KontaktPe__Aufwa__72C60C4A]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[KontaktPerson] ADD  DEFAULT ((0)) FOR [Aufwand_Ist]
GO
/****** Object:  Default [DF__KontaktPr__Konta__73BA3083]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[KontaktProjekt] ADD  DEFAULT ((0)) FOR [KontaktKey]
GO
/****** Object:  Default [DF__KontaktPr__Proje__74AE54BC]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[KontaktProjekt] ADD  DEFAULT ((0)) FOR [ProjektVersionKey]
GO
/****** Object:  Default [DF__LfdNr__Angebot__75A278F5]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[LfdNr] ADD  DEFAULT ((0)) FOR [Angebot]
GO
/****** Object:  Default [DF__LfdNr__Rechnung__76969D2E]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[LfdNr] ADD  DEFAULT ((0)) FOR [Rechnung]
GO
/****** Object:  Default [DF__Organisati__EPLZ__778AC167]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Organisation] ADD  DEFAULT ((0)) FOR [EPLZ]
GO
/****** Object:  Default [DF__Organisation__KG__787EE5A0]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Organisation] ADD  DEFAULT ((0)) FOR [KG]
GO
/****** Object:  Default [DF__Organisation__MB__797309D9]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Organisation] ADD  DEFAULT ((0)) FOR [MB]
GO
/****** Object:  Default [DF__Organisat__Kredi__7A672E12]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Organisation] ADD  DEFAULT ((0)) FOR [Kreditlimit]
GO
/****** Object:  Default [DF__Organisat__expor__7B5B524B]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Organisation] ADD  DEFAULT ((0)) FOR [export]
GO
/****** Object:  Default [DF__PersMaili__PersK__7C4F7684]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[PersMailingKrit] ADD  DEFAULT ((0)) FOR [PersKey]
GO
/****** Object:  Default [DF__PersMaili__Maili__7D439ABD]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[PersMailingKrit] ADD  DEFAULT ((0)) FOR [MailingKritKey]
GO
/****** Object:  Default [DF__Person__Geschlec__7E37BEF6]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Person] ADD  DEFAULT ((0)) FOR [Geschlecht]
GO
/****** Object:  Default [DF__Person__EPLZ__7F2BE32F]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Person] ADD  DEFAULT ((0)) FOR [EPLZ]
GO
/****** Object:  Default [DF__Person__MailingS__00200768]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Person] ADD  DEFAULT ((0)) FOR [MailingSperre]
GO
/****** Object:  Default [DF__Person__Mitarbei__01142BA1]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Person] ADD  DEFAULT ((0)) FOR [Mitarbeiter]
GO
/****** Object:  Default [DF__PersOrg__OrgKey__02084FDA]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[PersOrg] ADD  DEFAULT ((0)) FOR [OrgKey]
GO
/****** Object:  Default [DF__PersOrg__PersKey__02FC7413]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[PersOrg] ADD  DEFAULT ((0)) FOR [PersKey]
GO
/****** Object:  Default [DF__Postleitzah__LKZ__03F0984C]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Postleitzahl] ADD  DEFAULT ('A') FOR [LKZ]
GO
/****** Object:  Default [DF__Postleitza__Zone__04E4BC85]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Postleitzahl] ADD  DEFAULT ((0)) FOR [Zone]
GO
/****** Object:  Default [DF__Postleitz__Bunde__05D8E0BE]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Postleitzahl] ADD  DEFAULT ((0)) FOR [Bundesland]
GO
/****** Object:  Default [DF__Potential__OrgKe__06CD04F7]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Potential] ADD  DEFAULT ((0)) FOR [OrgKey]
GO
/****** Object:  Default [DF__Potential__Produ__07C12930]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Potential] ADD  DEFAULT ((0)) FOR [ProduktKey]
GO
/****** Object:  Default [DF__Potential__Menge__08B54D69]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Potential] ADD  DEFAULT ((0)) FOR [Menge]
GO
/****** Object:  Default [DF__Produktgr__Haupt__09A971A2]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Produktgruppe] ADD  DEFAULT ((0)) FOR [HauptgruppenKey]
GO
/****** Object:  Default [DF__Projekt__EPLZ__0A9D95DB]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Projekt] ADD  DEFAULT ((0)) FOR [EPLZ]
GO
/****** Object:  Default [DF__Projekt__Verkäuf__0B91BA14]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Projekt] ADD  DEFAULT ((0)) FOR [Verkäufer]
GO
/****** Object:  Default [DF__Projekt__Status__0C85DE4D]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Projekt] ADD  DEFAULT ((0)) FOR [Status]
GO
/****** Object:  Default [DF__Projekt__Erhalte__0D7A0286]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Projekt] ADD  DEFAULT ((0)) FOR [Erhalten]
GO
/****** Object:  Default [DF__Projekt1__Status__0E6E26BF]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Projekt1] ADD  DEFAULT ((0)) FOR [StatusKey]
GO
/****** Object:  Default [DF__Projekt1__Sachbe__0F624AF8]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Projekt1] ADD  DEFAULT ((0)) FOR [Sachbearbeiter]
GO
/****** Object:  Default [DF__Projekt1__Statis__10566F31]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Projekt1] ADD  DEFAULT ((0)) FOR [Statistik]
GO
/****** Object:  Default [DF__Projekt1__Abrech__114A936A]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Projekt1] ADD  DEFAULT ((0)) FOR [Abrechnung]
GO
/****** Object:  Default [DF__Projekt1__Aktuel__123EB7A3]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Projekt1] ADD  DEFAULT ((0)) FOR [Aktuell]
GO
/****** Object:  Default [DF__Projekt1__Leistu__1332DBDC]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Projekt1] ADD  DEFAULT ((0)) FOR [Leistungen]
GO
/****** Object:  Default [DF__Projekt1__Projek__14270015]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Projekt1] ADD  DEFAULT ((0)) FOR [ProjektVersion]
GO
/****** Object:  Default [DF__ProjektOr__OrgKe__151B244E]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[ProjektOrg] ADD  DEFAULT ((0)) FOR [OrgKey]
GO
/****** Object:  Default [DF__ProjektOr__Proje__160F4887]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[ProjektOrg] ADD  DEFAULT ((0)) FOR [ProjektKey]
GO
/****** Object:  Default [DF__ProjektOr__Proje__17036CC0]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[ProjektOrg] ADD  DEFAULT ((0)) FOR [ProjektFunktionsKey]
GO
/****** Object:  Default [DF__ProjektPe__Proje__17F790F9]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[ProjektPerson] ADD  DEFAULT ((0)) FOR [ProjektKey]
GO
/****** Object:  Default [DF__ProjektPe__PersK__18EBB532]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[ProjektPerson] ADD  DEFAULT ((0)) FOR [PersKey]
GO
/****** Object:  Default [DF__ProjektPe__Proje__19DFD96B]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[ProjektPerson] ADD  DEFAULT ((0)) FOR [ProjektFunktionsKey]
GO
/****** Object:  Default [DF__ProjektPr__DB_We__1AD3FDA4]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[ProjektProdukt] ADD  DEFAULT ((0)) FOR [DB_Wert]
GO
/****** Object:  Default [DF__ProjektPr__DB_Pr__1BC821DD]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[ProjektProdukt] ADD  DEFAULT ((0)) FOR [DB_Prozent]
GO
/****** Object:  Default [DF__ProjektPr__Zusat__1CBC4616]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[ProjektProdukt] ADD  DEFAULT ((0)) FOR [Zusatztext]
GO
/****** Object:  Default [DF__ProjektPr__Anbot__1DB06A4F]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[ProjektProdukt] ADD  DEFAULT ((0)) FOR [AnbotPosition]
GO
/****** Object:  Default [DF__ProjektPr__Einka__1EA48E88]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[ProjektProdukt] ADD  DEFAULT ((0)) FOR [Einkauf]
GO
/****** Object:  Default [DF__ProjektSt__Proje__1F98B2C1]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[ProjektStatus] ADD  DEFAULT ((0)) FOR [ProjektStatusKey]
GO
/****** Object:  Default [DF__ProjektVe__Proje__208CD6FA]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[ProjektVersion] ADD  DEFAULT ((0)) FOR [ProjektKey]
GO
/****** Object:  Default [DF__ProjektVe__Versi__2180FB33]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[ProjektVersion] ADD  DEFAULT ((0)) FOR [Version]
GO
/****** Object:  Default [DF__ProjektVe__Netto__22751F6C]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[ProjektVersion] ADD  DEFAULT ((0)) FOR [Netto1]
GO
/****** Object:  Default [DF__ProjektVe__Rabat__236943A5]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[ProjektVersion] ADD  DEFAULT ((0)) FOR [Rabatt_Prozent]
GO
/****** Object:  Default [DF__ProjektVe__Rabat__245D67DE]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[ProjektVersion] ADD  DEFAULT ((0)) FOR [Rabatt_Wert]
GO
/****** Object:  Default [DF__ProjektVe__Netto__25518C17]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[ProjektVersion] ADD  DEFAULT ((0)) FOR [Netto2]
GO
/****** Object:  Default [DF__ProjektVers__UST__2645B050]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[ProjektVersion] ADD  DEFAULT ((0)) FOR [UST]
GO
/****** Object:  Default [DF__ProjektVe__Brutt__2739D489]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[ProjektVersion] ADD  DEFAULT ((0)) FOR [Brutto]
GO
/****** Object:  Default [DF__ProjektVe__DB_We__282DF8C2]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[ProjektVersion] ADD  DEFAULT ((0)) FOR [DB_Wert]
GO
/****** Object:  Default [DF__ProjektVe__DB_Pr__29221CFB]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[ProjektVersion] ADD  DEFAULT ((0)) FOR [DB_Prozent]
GO
/****** Object:  Default [DF__ProjektVe__Summe__2A164134]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[ProjektVersion] ADD  DEFAULT ((0)) FOR [Summe_Einkauf]
GO
/****** Object:  Default [DF__SetKlass__Key__2B0A656D]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[SetKlass] ADD  DEFAULT ((0)) FOR [Key]
GO
/****** Object:  Default [DF__SetKlass__ListKe__2BFE89A6]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[SetKlass] ADD  DEFAULT ((0)) FOR [ListKey]
GO
/****** Object:  Default [DF__Verrechnu__VerSa__2CF2ADDF]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Verrechnungssatz] ADD  DEFAULT ((0)) FOR [VerSatzHöhe]
GO
/****** Object:  Default [DF__Vorlage__Serienb__2DE6D218]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Vorlage] ADD  DEFAULT ((0)) FOR [Serienbrief]
GO
/****** Object:  Default [DF__Vorlage__AutoTex__2EDAF651]    Script Date: 08/10/2012 23:14:06 ******/
ALTER TABLE [dbo].[Vorlage] ADD  DEFAULT ((0)) FOR [AutoText]


